package by.bsu.scs.db.dao;

// Generated 05.03.2011 11:02:55 by Hibernate Tools 3.4.0.CR1

import java.text.MessageFormat;
import java.util.ArrayList;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.HibernateException;
import org.hibernate.LockMode;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Example;

import by.bsu.scs.model.MarkPolicy;
import by.bsu.scs.model.User;
import by.bsu.scs.util.db.HibernateUtil;
import by.bsu.scs.util.manager.PropertyManager;

/**
 * Home object for domain model class MarkPolicy.
 * 
 * @see by.bsu.scs.model.MarkPolicy
 * @author Hibernate Tools
 */
public class MarkPolicyHome {
	
	private static final Logger LOGGER = Logger.getLogger(MarkPolicyHome.class);

	private Session session = null;
	private Transaction transaction = null;

	public void persist(MarkPolicy transientInstance) {
		LOGGER.info("persisting MarkPolicy instance");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			session.save(transientInstance);
			transaction.commit();
			LOGGER.info("persist successful");
		} catch (HibernateException e) {
			transaction.rollback();
			LOGGER.error("persist failed", e.getCause());
		}
	}

	public void attachDirty(MarkPolicy instance) {
		LOGGER.info("attaching dirty MarkPolicy instance");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			session.saveOrUpdate(instance);
			transaction.commit();
			LOGGER.info("attach successful");
		} catch (HibernateException e) {
			transaction.rollback();
			LOGGER.error("attach failed", e.getCause());
		}
	}

	@SuppressWarnings("deprecation")
	public void attachClean(MarkPolicy instance) {
		LOGGER.info("attaching clean MarkPolicy instance");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			session.lock(instance, LockMode.NONE);
			transaction.commit();
			LOGGER.info("attach successful");
		} catch (HibernateException e) {
			transaction.rollback();
			LOGGER.error("attach failed", e.getCause());
		}
	}

	public void delete(MarkPolicy persistentInstance) {
		LOGGER.info("deleting MarkPolicy instance");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			session.delete(persistentInstance);
			transaction.commit();
			LOGGER.info("delete successful");
		} catch (HibernateException e) {
			transaction.rollback();
			LOGGER.error("delete failed", e.getCause());
		}
	}

	public MarkPolicy merge(MarkPolicy detachedInstance) {
		LOGGER.info("merging MarkPolicy instance");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			MarkPolicy result = (MarkPolicy) session.merge(detachedInstance);
			transaction.commit();
			LOGGER.info("merge successful");
			return result;
		} catch (HibernateException e) {
			transaction.rollback();
			LOGGER.error("merge failed", e.getCause());
			return null;
		}
	}

	public MarkPolicy findById(int id) {
		LOGGER.info("getting MarkPolicy instance with id: " + id);
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			MarkPolicy instance = (MarkPolicy) session.get(
					"by.bsu.scs.model.MarkPolicy", id);
			if (instance == null) {
				LOGGER.info("get successful, no instance found");
			} else {
				LOGGER.info("get successful, instance found");
			}
			transaction.commit();
			return instance;
		} catch (RuntimeException e) {
			transaction.rollback();
			LOGGER.error("get failed", e.getCause());
			return null;
		}
	}

	@SuppressWarnings("rawtypes")
	public List findByExample(MarkPolicy instance) {
		LOGGER.info("finding MarkPolicy instance by example");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();
			Example example = Example.create(instance).excludeZeroes();
			List results = session
					.createCriteria("by.bsu.scs.model.MarkPolicy").add(example)
					.list();
			LOGGER.info("find by example successful, result size: "
					+ results.size());
			transaction.commit();
			return results;
		} catch (RuntimeException e) {
			transaction.rollback();
			LOGGER.error("find by example failed", e.getCause());
			return null;
		}
	}

	// ******************** Custom SQL - queries ********************

	@SuppressWarnings({ "rawtypes", "unchecked" })
	public List<MarkPolicy> getMarkPoliciesByIdCreator(User instructor) {
		LOGGER.info("finding mark policies by instructor id");
		session = HibernateUtil.openCurrentSession();
		try {
			transaction = session.beginTransaction();

			String sql = PropertyManager.getInstance().getProperty(
					PropertyManager.MARK_POLICY_BY_ID_CREATOR_SQL);

			Object[] params = { instructor.getUserId() };
			MessageFormat messageToFormat = new MessageFormat(sql);
			sql = messageToFormat.format(params);

			List results = session.createSQLQuery(sql).list();

			LOGGER.info("find successful, result size: " + results.size());
			transaction.commit();
			return parseMarkPolicyData(results);
		} catch (RuntimeException e) {
			transaction.rollback();
			LOGGER.error("find failed", e.getCause());
			return null;
		}
	}

	private List<MarkPolicy> parseMarkPolicyData(List<Object> results) {
		List<MarkPolicy> mpList = new ArrayList<MarkPolicy>();
		for (Object o : results) {
			Object[] mpData = (Object[]) o;
			MarkPolicy mp = new MarkPolicy();

			mp.setMarkPolicyId((Integer) mpData[0]);
			mp.setPolicyShort((String) mpData[1]);
			mp.setPolicyDescription((String) mpData[2]);
			mp.setIdCreator((Integer) mpData[3]);
			mp.setVisible(true);

			mpList.add(mp);
		}
		return mpList;
	}
}
